﻿package com.fandy.struts.DAL;

import java.sql.ResultSet;

import com.fandy.struts.SqlAccess.SqlServerHelper;
import com.fandy.struts.SqlStatement.sellinfo;


public class DALSellinfo {
 
	
	sellinfo si = new sellinfo(); 
	SqlServerHelper ssh = new SqlServerHelper();

	public   ResultSet  getAll()
	{
		return   ssh.executeScalar(si.getAll());
	}
	
	public   ResultSet getSellInfoByDepID(int departmentID)
	{
		return  ssh.executeScalar(si.getSellInfoByDepID(departmentID));
	}
	
	
	public   ResultSet getSellInfoByStaffID(int StaffID)
	{
		return   ssh.executeScalar(si.getSellInfoByStaffID(StaffID));
	}
	
	public   ResultSet getSellInfoByMagID(int ManagerID)
	{
		return   ssh.executeScalar(si.getSellInfoByMagID(ManagerID));
	}
	
	public   ResultSet getSellInfoByGoodsID(int GoodsID)
	{
		return   ssh.executeScalar(si.getSellInfoByGoodsID(GoodsID));
	}



}

